Overview

Dataset Statistics

Number of Variables 19
Number of Rows 10129
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 2.6 MB
Average Row Size in Memory 267.4 B
Variable Types
  • Categorical: 5
  • Numerical: 14

Dataset Insights

S2_Temp is skewed Skewed
S1_Light is skewed Skewed
S2_Light is skewed Skewed
S3_Light is skewed Skewed
S4_Light is skewed Skewed
S1_Sound is skewed Skewed
S2_Sound is skewed Skewed
S3_Sound is skewed Skewed
S4_Sound is skewed Skewed
S5_CO2 is skewed Skewed
S5_CO2_Slope is skewed Skewed
Time has a high cardinality: 10129 distinct values High Cardinality
S6_PIR has constant length 1 Constant Length
S7_PIR has constant length 1 Constant Length
Room_Occupancy_Count has constant length 1 Constant Length
Time has all distinct values Unique
S5_CO2_Slope has 3128 (30.88%) negatives Negatives
S1_Light has 5845 (57.71%) zeros Zeros
S2_Light has 5846 (57.72%) zeros Zeros
S3_Light has 5591 (55.2%) zeros Zeros
S4_Light has 5599 (55.28%) zeros Zeros
S5_CO2_Slope has 4495 (44.38%) zeros Zeros
  • 1
  • 2
  • 3

Variables


Date

categorical

Approximate Distinct Count 7
Approximate Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 757630
  • The largest value (12/23/2017) is over 1.62 times larger than the second largest value (12/25/2017)

Length

Mean 9.7981
Standard Deviation 0.4014
Median 10
Minimum 9
Maximum 10

Sample

1st row 12/22/2017
2nd row 12/22/2017
3rd row 12/22/2017
4th row 12/22/2017
5th row 12/22/2017

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 78987
  • The largest value (12232017) is over 1.62 times larger than the second largest value (12252017)

Time

categorical

Approximate Distinct Count 10129
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Memory Size 734992

Length

Mean 7.5631
Standard Deviation 0.496
Median 8
Minimum 7
Maximum 8

Sample

1st row 10:49:41
2nd row 10:50:12
3rd row 10:50:42
4th row 10:51:13
5th row 10:51:44

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 56349
  • Time contains many words: 10129 words

S1_Temp

numerical

Approximate Distinct Count 24
Approximate Unique (%) 0.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 25.454
Minimum 24.94
Maximum 26.38
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • S1_Temp is skewed right (γ1 = 0.9535)

Quantile Statistics

Minimum 24.94
5-th Percentile 25.06
Q1 25.19
Median 25.38
Q3 25.63
95-th Percentile 26.19
Maximum 26.38
Range 1.44
IQR 0.44

Descriptive Statistics

Mean 25.454
Standard Deviation 0.3514
Variance 0.1234
Sum 257823.69
Skewness 0.9535
Kurtosis -0.1569
Coefficient of Variation 0.0138
  • S1_Temp is not normally distributed (p-value 5.066829650572937e-06)
  • S1_Temp has 162 outliers

S2_Temp

numerical

Approximate Distinct Count 69
Approximate Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 25.5461
Minimum 24.75
Maximum 29
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • S2_Temp is skewed right (γ1 = 2.3553)

Quantile Statistics

Minimum 24.75
5-th Percentile 25.06
Q1 25.19
Median 25.38
Q3 25.63
95-th Percentile 26.81
Maximum 29
Range 4.25
IQR 0.44

Descriptive Statistics

Mean 25.5461
Standard Deviation 0.5863
Variance 0.3438
Sum 258756.03
Skewness 2.3553
Kurtosis 6.5025
Coefficient of Variation 0.02295
  • S2_Temp is not normally distributed (p-value 2.185009003825846e-10)
  • S2_Temp has 948 outliers

S3_Temp

numerical

Approximate Distinct Count 29
Approximate Unique (%) 0.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 25.0566
Minimum 24.44
Maximum 26.19
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • S3_Temp is skewed right (γ1 = 0.6501)

Quantile Statistics

Minimum 24.44
5-th Percentile 24.5
Q1 24.69
Median 24.94
Q3 25.38
95-th Percentile 25.88
Maximum 26.19
Range 1.75
IQR 0.69

Descriptive Statistics

Mean 25.0566
Standard Deviation 0.4273
Variance 0.1826
Sum 253798.51
Skewness 0.6501
Kurtosis -0.5469
Coefficient of Variation 0.01705

S4_Temp

numerical

Approximate Distinct Count 27
Approximate Unique (%) 0.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 25.7541
Minimum 24.94
Maximum 26.56
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • S4_Temp is skewed right (γ1 = 0.1296)

Quantile Statistics

Minimum 24.94
5-th Percentile 25.19
Q1 25.44
Median 25.75
Q3 26
95-th Percentile 26.31
Maximum 26.56
Range 1.62
IQR 0.56

Descriptive Statistics

Mean 25.7541
Standard Deviation 0.3564
Variance 0.127
Sum 260863.53
Skewness 0.1296
Kurtosis -0.9318
Coefficient of Variation 0.01384
  • S4_Temp is not normally distributed (p-value 0.008821504000601608)

S1_Light

numerical

Approximate Distinct Count 68
Approximate Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 25.4451
Minimum 0
Maximum 165
Zeros 5845
Zeros (%) 57.7%
Negatives 0
Negatives (%) 0.0%
  • S1_Light is skewed right (γ1 = 1.8202)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 12
95-th Percentile 150
Maximum 165
Range 165
IQR 12

Descriptive Statistics

Mean 25.4451
Standard Deviation 51.0113
Variance 2602.1491
Sum 257733
Skewness 1.8202
Kurtosis 1.5153
Coefficient of Variation 2.0048
  • S1_Light is not normally distributed (p-value 1.9954568970226784e-24)
  • S1_Light has 1716 outliers

S2_Light

numerical

Approximate Distinct Count 82
Approximate Unique (%) 0.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 26.0163
Minimum 0
Maximum 258
Zeros 5846
Zeros (%) 57.7%
Negatives 0
Negatives (%) 0.0%
  • S2_Light is skewed right (γ1 = 2.8274)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 14
95-th Percentile 237
Maximum 258
Range 258
IQR 14

Descriptive Statistics

Mean 26.0163
Standard Deviation 67.3042
Variance 4529.8513
Sum 263519
Skewness 2.8274
Kurtosis 6.1837
Coefficient of Variation 2.587
  • S2_Light is not normally distributed (p-value 2.5735884457095917e-24)
  • S2_Light has 1017 outliers

S3_Light

numerical

Approximate Distinct Count 177
Approximate Unique (%) 1.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 34.2485
Minimum 0
Maximum 280
Zeros 5591
Zeros (%) 55.2%
Negatives 0
Negatives (%) 0.0%
  • S3_Light is skewed right (γ1 = 2.0998)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 50
95-th Percentile 181
Maximum 280
Range 280
IQR 50

Descriptive Statistics

Mean 34.2485
Standard Deviation 58.4007
Variance 3410.6469
Sum 346903
Skewness 2.0998
Kurtosis 3.883
Coefficient of Variation 1.7052
  • S3_Light is not normally distributed (p-value 1.1593745917063967e-24)
  • S3_Light has 950 outliers

S4_Light

numerical

Approximate Distinct Count 75
Approximate Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 13.2203
Minimum 0
Maximum 74
Zeros 5599
Zeros (%) 55.3%
Negatives 0
Negatives (%) 0.0%
  • S4_Light is skewed right (γ1 = 1.3574)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 22
95-th Percentile 56
Maximum 74
Range 74
IQR 22

Descriptive Statistics

Mean 13.2203
Standard Deviation 19.6022
Variance 384.247
Sum 133908
Skewness 1.3574
Kurtosis 0.57
Coefficient of Variation 1.4827
  • S4_Light is not normally distributed (p-value 6.6673599902007425e-25)
  • S4_Light has 543 outliers

S1_Sound

numerical

Approximate Distinct Count 231
Approximate Unique (%) 2.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 0.1682
Minimum 0.06
Maximum 3.88
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • S1_Sound is skewed right (γ1 = 5.4496)

Quantile Statistics

Minimum 0.06
5-th Percentile 0.06
Q1 0.07
Median 0.08
Q3 0.08
95-th Percentile 0.72
Maximum 3.88
Range 3.82
IQR 0.01

Descriptive Statistics

Mean 0.1682
Standard Deviation 0.3167
Variance 0.1003
Sum 1703.47
Skewness 5.4496
Kurtosis 39.3951
Coefficient of Variation 1.8832
  • S1_Sound is not normally distributed (p-value 4.630592292851975e-25)
  • S1_Sound has 1772 outliers

S2_Sound

numerical

Approximate Distinct Count 185
Approximate Unique (%) 1.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 0.1201
Minimum 0.04
Maximum 3.44
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • S2_Sound is skewed right (γ1 = 6.8806)

Quantile Statistics

Minimum 0.04
5-th Percentile 0.04
Q1 0.05
Median 0.05
Q3 0.06
95-th Percentile 0.43
Maximum 3.44
Range 3.4
IQR 0.01

Descriptive Statistics

Mean 0.1201
Standard Deviation 0.2665
Variance 0.07102
Sum 1216.15
Skewness 6.8806
Kurtosis 62.4414
Coefficient of Variation 2.2196
  • S2_Sound is not normally distributed (p-value 4.80545540747141e-25)
  • S2_Sound has 1703 outliers

S3_Sound

numerical

Approximate Distinct Count 258
Approximate Unique (%) 2.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 0.1581
Minimum 0.04
Maximum 3.67
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • S3_Sound is skewed right (γ1 = 5.9939)

Quantile Statistics

Minimum 0.04
5-th Percentile 0.05
Q1 0.06
Median 0.06
Q3 0.07
95-th Percentile 0.55
Maximum 3.67
Range 3.63
IQR 0.01

Descriptive Statistics

Mean 0.1581
Standard Deviation 0.4136
Variance 0.1711
Sum 1601.59
Skewness 5.9939
Kurtosis 39.4577
Coefficient of Variation 2.616
  • S3_Sound is not normally distributed (p-value 4.829312015257763e-25)
  • S3_Sound has 1671 outliers

S4_Sound

numerical

Approximate Distinct Count 106
Approximate Unique (%) 1.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 0.1038
Minimum 0.05
Maximum 3.4
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • S4_Sound is skewed right (γ1 = 10.9505)

Quantile Statistics

Minimum 0.05
5-th Percentile 0.06
Q1 0.06
Median 0.08
Q3 0.1
95-th Percentile 0.23
Maximum 3.4
Range 3.35
IQR 0.04

Descriptive Statistics

Mean 0.1038
Standard Deviation 0.1207
Variance 0.01456
Sum 1051.8
Skewness 10.9505
Kurtosis 211.0672
Coefficient of Variation 1.1622
  • S4_Sound is not normally distributed (p-value 4.747243735420671e-25)
  • S4_Sound has 721 outliers

S5_CO2

numerical

Approximate Distinct Count 186
Approximate Unique (%) 1.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean 460.8604
Minimum 345
Maximum 1270
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • S5_CO2 is skewed right (γ1 = 1.9754)

Quantile Statistics

Minimum 345
5-th Percentile 345
Q1 355
Median 360
Q3 465
95-th Percentile 955
Maximum 1270
Range 925
IQR 110

Descriptive Statistics

Mean 460.8604
Standard Deviation 199.9649
Variance 39985.9772
Sum 4.6681e+06
Skewness 1.9754
Kurtosis 2.9993
Coefficient of Variation 0.4339
  • S5_CO2 is not normally distributed (p-value 2.6966475954485447e-24)
  • S5_CO2 has 1657 outliers

S5_CO2_Slope

numerical

Approximate Distinct Count 1579
Approximate Unique (%) 15.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 162064
Mean -0.00483
Minimum -6.2962
Maximum 8.9808
Zeros 4495
Zeros (%) 44.4%
Negatives 3128
Negatives (%) 30.9%
  • S5_CO2_Slope is skewed right (γ1 = 0.2879)

Quantile Statistics

Minimum -6.2962
5-th Percentile -2.0831
Q1 -0.04615
Median 0
Q3 0
95-th Percentile 2.1462
Maximum 8.9808
Range 15.2769
IQR 0.04615

Descriptive Statistics

Mean -0.00483
Standard Deviation 1.165
Variance 1.3572
Sum -48.9231
Skewness 0.2879
Kurtosis 7.3976
Coefficient of Variation -241.1986
  • S5_CO2_Slope is not normally distributed (p-value 7.709441503914834e-25)
  • S5_CO2_Slope has 3996 outliers

S6_PIR

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 668514
  • The largest value (0) is over 10.09 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 10129
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 10.09 times larger than the second largest value (1)
  • S6_PIR has words of constant length

S7_PIR

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 668514
  • The largest value (0) is over 11.57 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 10129
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 11.57 times larger than the second largest value (1)
  • S7_PIR has words of constant length

Room_Occupancy_Count

categorical

Approximate Distinct Count 4
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 668514
  • The largest value (0) is over 11.0 times larger than the second largest value (2)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 1
2nd row 1
3rd row 1
4th row 1
5th row 1

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 10129
  • The top 2 categories (0, 2) take over 50.0%
  • The largest value (0) is over 11.0 times larger than the second largest value (2)
  • Room_Occupancy_Count has words of constant length

Interactions

Correlations

Missing Values